package com.hnhcyy.goods.mapper;

import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Select;

import com.hnhcyy.goods.pojo.SpkfkOperateLog;


/**
 * 商品操作日志表
 * @author sheyongjun  
 * @date 2019年2月16日
 */
public interface SpkfkOperateLogMapper {
	
	@Insert("insert into spkfk_operate_log(id,spid,operate_method,operate_description,operate_before,operate_after,sjid,operator,ip)"+
			" values (#{id},#{spid},#{operateMethod},#{operateDescription},#{operateBefore},#{operateAfter},#{sjid},#{operator},#{ip})")
	public int insert(SpkfkOperateLog item);	
	
	@Select("select id,spid,operate_method,operate_description,operate_before,operate_after,sjid,operator,ip,operate_time,operate_time"+
			" from spkfk_operate_log where id=#{id}")
	public SpkfkOperateLog select(String spid);
}
